Full period calculations can be applied on a dateKey hierarchy that has a level type of Date (red highlight below). Selecting a dateKey hierarchy from the Time Intelligence wizard exposes the Periods column, containing Full Period calculations, and the Parallel Period column, containing Parallel Period calculations.
Full Period: these calculations return a list of dates from the chosen full period of the given date. For instance, creating a Full Month calculation, and selecting a date of August 3 2019 will return a list of all dates in August 2019. However, selecting August 3 2019 from a Full Quarter list will return a list of all dates in Q3 2019.
Full Period functions generate the following elements:
- A parameter, which is used to inject a date into the query at runtime.
- Custom calculations, which return the total for the given full period when added to the query.
- Custom lists, which return a list of all dates in the given full period.
Parallel Period: returns a list of dates from the full period prior to the period of the given date. For example, selecting August 3 2019 from a full month list will return a list of all dates in July 2019.
Full Period functions generate the following elements:
- A parameter, which is used to inject a date into the query at runtime.
- Full Period custom calculations, which return a the total for the given full period when added to the query.
- Full Period custom lists, which return a list of all dates in the given full period.
- Parallel Period custom calculations, which return the total for the parallel period prior to the given full period.
- Parallel Period custom lists, which return a list of all dates in the parallel period prior to the given full period
Examples
Full Week
In this example, a Full Week calculation is applied to the dateKey hierarchy:
The Full Week calculation produces a parameter, a custom member, and a custom list. When the list (green arrow) or the custom member (blue arrow) is added to the query, the parameter is also added automatically (red highlight).
When a date is selected from the parameter, the full week of that date is returned; the list displays each day in the given week (green highlight), while the custom member displays the total week (blue highlight).
Parallel Period: Full Week
Here, the Parallel Period: Full Week calculation is applied from the Time Intelligence wizard:
Both Full Period and Parallel Period elements are generated. When either the parallel period list (green arrow) or the parallel period custom member (blue arrow) is added to the query, the parameter will also be added by default (red highlight).
The parallel period list returns a list of dates for the full week, 1 week prior to the date selected in the parameter (green highlight). The parallel period custom member returns the total for the full week prior to the given week (blue highlight).
Here, both the full period list and custom member (red highlight) are added to the query; the grid displays the parallel period list and custom member (blue highlights), and the full period list and custom member (green highlight).
